package com.gzrhhscd.mapper;
import com.gzrhhscd.Pojo.Emp;
import org.apache.ibatis.annotations.*;

import java.time.LocalDate;
import java.util.List;

@Mapper
 public interface EmpMapper {
// @Select("select count(*) from emp")
//  long count();
// @Select("select * from emp limit #{start}, #{pageSize}")
// List<Emp>Page(Integer start, Integer pageSize);


// @Select("select * from emp")
 List<Emp>list(String name,Short gender,LocalDate begin,LocalDate end);

 void delete(List<Integer> ids);
@Insert("insert into emp (username, name, gender, image, job, entryDate, dept_id, create_time, update_time)"+
        " VALUES(#{username},#{name},#{gender},#{image},#{job},#{entryDate},#{deptId},#{createTime},#{updateTime}) ")
 void insert(Emp emp);
@Select("select * from emp where id=#{id}")
 Emp getByID(Integer id);
 void update(Emp emp);

@Select("select * from emp where username=#{username} and password=#{password}")
    Emp getByUsernameAndPassword(Emp emp);

    void deleteEmpByDeptId(Integer id);
}
